Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/check_scheduled_tasks.sql

Last active June 28, 2020 12:54
Show Gist options
  • Save vvgsrk/7a3cb53e34f40b511da032938bb283a1 to your computer and use it in GitHub Desktop.
Save vvgsrk/7a3cb53e34f40b511da032938bb283a1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
check_scheduled_tasks.sql
SELECT scheduled_time, name, state
FROM TABLE(information_schema.task_history())
WHERE database_name = 'DB_DEV'
AND schema_name = 'REVENUE'
AND name = 'FA_UNLOAD_TASK'
ORDER BY completed_time desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment